package com.mapper;

import com.pojo.view.TotalShoppingPriceView;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
public interface TotalShoppingPriceViewMapper {
    @Select("select product_quantity productQuantity," +
            "product_id productId, " +
            "consumer_phone consumerPhone, " +
            "size_id sizeId, " +
            "total_price totalPrice " +
            "from total_shopping_price_view " +
            "where consumer_phone =#{phone}")
    List<TotalShoppingPriceView> byPhoneGetPrice(String phone);

}
